
* [] brackets indicate redacted internal census variable name or directory that can't be disclosed. ;


libname icf '[directory location of geocoded worker residence files]';
libname hannah  '/projects/users/########';


proc sql;
  create table hannah.randpiks as
  select * from icf.icf_us_addresses where rand('Uniform') <= 0.01
  order by pik, [year];
quit;

data hannah.randpiks;
  set hannah.randpiks (keep = pik);
run;

proc sort data=hannah.randpiks nodupkey;
  by pik;
run;

proc sql;
  create table hannah.randpiks as select
  a.*, b.*
  from hannah.ehf_icf_states_plants as a 
    left join hannah.randpiks as b on a.pik=b.pik
    where a.pik = b.pik
  order by a.pik, a.year;
quit;



